<%@ page import="java.sql.*,studentportal.*"%>
<html>

<head>
 
<title>New Page 1</title>
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" width="100%">
  <tr>
     <td width="20%">
      <p align="center"><font face="Trebuchet MS, Arial, Helvetica">
      <a href="FacultyPersonalInfoView.jsp"><b>Personal Info</b></a></font></td>

     <td width="20%">
      <p align="center"><font face="Trebuchet MS, Arial, Helvetica">
      <a href="FacultyListCourses.jsp"><b>View Courses</b></a></font></td>
   
    <td width="20%">
      <p align="center"><a href="Home.html"><b>Home</b></a></td>
  </tr>
</table><br/><br/>
<form method="get" action="./FacultyMarkStore.jsp">
<table border="1" align="center">
	<tr>
			<th>Notes Name</th>
			<th>Description</th>
			<th>Attachment Name</th>
			<th>Date</th>
			<th>File Download</th>
			<th>Delete</th>
			<th>Student Replay</th>
	</tr>
<%
try
{
			String fid=(String)session.getAttribute("FacultyID");
			Connection con=MySQLDriver.getConnection();
			Statement st=con.createStatement();
			
			String qry="SELECT * FROM faculty_assignment_master where assign_id="+request.getParameter("ID");//+" and faculty_id="+fid; 
			ResultSet rs=st.executeQuery(qry);
			while(rs.next())
			{
%>
				<tr>
					<td><%=rs.getString(3) %></td>
					<td><%=rs.getString(4) %></td>
					<td><%=rs.getString(5) %></td>
					<td><%=rs.getString(7) %></td>
					<td><a href='FileDownload.jsp?fileName=<%=rs.getString(8)%>&file=<%=rs.getString(6)%>'/>Download</a></td>
					<td><a href='FacultyDeleteAssignment.jsp?ID=<%=rs.getString(1)%>&file=<%=rs.getString(6)%>'/>Delete</a></td>
					<td><a href='FacultyStudentAssignmentList.jsp?IID=<%=rs.getString(1)%>&ID=<%=rs.getString(2)%>'/>Replay</a></td>
				</tr>
<%
			}
}
catch(Exception e)
{
	%>
		<tr>
				<td>	<%="No Students"%></td>
		</tr>
<%

}

%>
	</table>
</form>
</body>

</html>
